package com.dhecp.project.purchase.controller;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.apache.shiro.authz.annotation.Logical;
import org.apache.shiro.authz.annotation.RequiresPermissions;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.servlet.ModelAndView;

import com.dhecp.common.annotation.Log;
import com.dhecp.common.annotation.RepeatSubmit;
import com.dhecp.common.config.Global;
import com.dhecp.common.core.domain.AjaxResult;
import com.dhecp.common.core.page.TableDataInfo;
import com.dhecp.common.enums.BusinessType;
import com.dhecp.common.utils.MessageUtils;
import com.dhecp.common.utils.TypeUtils;
import com.dhecp.core.constant.ModuleTable;
import com.dhecp.core.utils.DateUtil;
import com.dhecp.core.utils.ExportExcelUtils;
import com.dhecp.core.utils.PdfUtil;
import com.dhecp.framework.util.ShiroUtils;
import com.dhecp.project.base.domain.CompanyInfo;
import com.dhecp.project.base.service.CompanyInfoService;
import com.dhecp.project.common.controller.BaseModuleController;
import com.dhecp.project.common.domain.ModuleNidAndBid;
import com.dhecp.project.common.service.ModuleNidAndBidService;
import com.dhecp.project.flowable.domain.ActHistoricActivity;
import com.dhecp.project.flowable.service.ActProcessService;
import com.dhecp.project.purchase.domain.OfflinePayment;
import com.dhecp.project.purchase.service.OfflinePaymentService;
import com.dhecp.project.system.domain.SysDictionaryForExport;
import com.dhecp.project.system.domain.SysUserInfo;
import com.dhecp.project.system.service.SysDictionaryForFieldService;
import com.dhecp.project.system.service.SysUserInfoService;

/**
 * @program: kjecp
 * @description: 线下采购付款
 * @author: hlf
 * @create: 2022-11-03 11:34
 */
@Controller
@RequestMapping("/purchase/offlinepayment")
public class OfflinePaymentController extends BaseModuleController {

    private String prefix = "purchase/offlinepayment";
    private String moduleTable = ModuleTable.OFFLINE_PAYMENT;

    @Autowired
    private ActProcessService actProcessService;
    @Autowired
    private CompanyInfoService companyInfoService;
    @Autowired
    private OfflinePaymentService businessService;
    @Autowired
    private SysUserInfoService sysUserInfoService;

    @Autowired
    private ModuleNidAndBidService moduleNidAndBidService;

    @Autowired
    private SysDictionaryForFieldService dictionaryForFieldService;

    /**
     * 打开查询列表页
     * @param params
     * @return
     * @author DH-Xxj
     */
    @RequiresPermissions("purchase:offlinepayment:view")
    @GetMapping()
    public ModelAndView listPage(@RequestParam Map<String, Object> params){
        params.put("moduleTable", moduleTable);
        params.put("entity", new OfflinePayment()); //生成表格gridColumns对应的实体，用于获取实体属性生成表格字段
        params.put("prefix","purchase/purchase"); //页面路径
        ModelAndView mv = this.openListPage(params);
        mv.addObject("purchase", "offlinepayment");
        return mv;
    }


    /**
     * 打开制单页
     * @param nid 必要参数：单据编码（新增时传默认值 0 ，修改、查看时传单据实际值）
     * @return
     * @author DH-Xxj
     */
    @RequiresPermissions("purchase:offlinepayment:view")
    @GetMapping("/edit")
    public ModelAndView editPage(@RequestParam Map<String, Object> params){
        if (params.get("nid") == null || params.get("nid") == ""){
            params.put("nid", "0");
        }
        params.put("moduleTable", moduleTable);
        params.put("entity", new OfflinePayment()); //用于获取实体属性名取代对应字典字段名，解决大小写敏感问题
        params.put("moduleUrl", prefix); //页面上级路径
        params.put("prefix", prefix + "/offlinepayment_edit"); //页面路径

        try{
            Map<String, Object> headData = new HashMap<String, Object>();		//表头的业务数据
//          SysModuleSet moduleSet = sysModuleSetService.queryModuleSet(params);//单据设置信息
            OfflinePayment businessData = businessService.queryFirstRecord(params);
            if (businessData == null){ //未查询到对应单据，页面初始化值
                ModuleNidAndBid moduleNidAndBid = moduleNidAndBidService.queryModuleNidAndBidInitial(params);
                OfflinePayment businessDataNew = new OfflinePayment();
                businessDataNew.setNid("0");
                businessDataNew.setBid(moduleNidAndBid.getBid());
                businessDataNew.setCreateTime(new Date());
                businessDataNew.setCid(ShiroUtils.getMandatorCid());
                businessDataNew.setCidName(ShiroUtils.getMandatorCidName());
                businessDataNew.setbUser(ShiroUtils.getMandatorId());
                businessDataNew.setbUserName(ShiroUtils.getMandatorName());
                businessDataNew.setbDept(ShiroUtils.getMandatorDeptPath());
                businessDataNew.setbDeptName(ShiroUtils.getMandatorDeptName());
                businessDataNew.setbPosition(ShiroUtils.getMandatorPositionNameDa());
                businessDataNew.setaUser(ShiroUtils.getUserId());
                businessDataNew.setaUserName(ShiroUtils.getUserName());
                businessDataNew.setaDept(ShiroUtils.getUserDeptPath());
                businessDataNew.setaDeptName(ShiroUtils.getUserDeptName());
                businessDataNew.setaPosition(ShiroUtils.getUserPositionNameDa());
                headData = TypeUtils.entityToMap(businessDataNew);
            }else{
                headData = TypeUtils.entityToMap(businessData);
            }
            params.put("headData", headData); //表头的业务数据

            params.put("checkBox", "yes"); //生成表格gridColumns时包含复选
            ModelAndView mv = this.openEditPage(params);
            return mv;
        }catch(Exception e){
//    		return this.gotoModelAndViewErrorPage(this.getExceptionMessage(e));	//简单信息
            return this.gotoModelAndViewErrorPage(e.getMessage());	//详细信息
        }

    }

    /**
     * 打开流转页
     * @param fType 必要参数：审核类型（flow_go：流转，flow_back：退回）
     * @param infoMap 必要参数：非网格字段（包括所有显示和隐藏的字段），json格式字符串
     * @return
     * @author DH-Xxj
     */
    @RequiresPermissions("purchase:offlinepayment:flow")
    @PostMapping("/flowpage")
    @ResponseBody
    public AjaxResult flowPage(@RequestParam Map<String, Object> params){
        params.put("moduleTable", moduleTable);
        params.put("prefix", prefix);
//		String flowUrl = flowPageUrl(params);
//		return redirect(flowUrl);
        return openFlowPage(params);
    }

    /**
     * 制单页 明细数据
     * @param nid 必要参数：当前 单据编码
     * @return
     * @author DH-Xxj
     */
    @RequiresPermissions("purchase:offlinepayment:list")
    @GetMapping("/listbynid")
    @ResponseBody
    public TableDataInfo listByNid(@RequestParam Map<String, Object> params){
        if (params.get("nid") == null || params.get("nid") == ""){
            return getDataTable(MessageUtils.message("module.error.lack.nid"));
        }
        params.put("moduleTable", moduleTable);
        List<OfflinePayment> list = new ArrayList<OfflinePayment>();
        try {
            list = businessService.queryListByNid(params);
        } catch (Exception e) {
            e.printStackTrace();
            return getDataTable(this.getExceptionMessage(e).toString());
        }
        return getDataTable(list);
    }

    /**
     * 查询前一单NID、BID
     * @param nid 必要参数：当前 单据编码
     * @return AjaxResult (data.nid 前一单NID， data.bid 前一单BID)
     * @author DH-Xxj
     */
    @RequiresPermissions("purchase:offlinepayment:view")
    @GetMapping("/lastnid")
    @ResponseBody
    public AjaxResult lastNid(@RequestParam Map<String, Object> params){
        params.put("moduleTable", moduleTable);
        AjaxResult ajaxResult = new AjaxResult();
        try {
            ajaxResult = businessService.queryLastNid(params);
        }catch (Exception e) {
            ajaxResult = AjaxResult.error(this.getExceptionMessage(e));
        }
        return ajaxResult;
    }

    /**
     * 查询后一单NID、BID
     * @param nid 必要参数：当前 单据编码
     * @return AjaxResult (data.nid 后一单NID， data.bid 后一单BID)
     * @author DH-Xxj
     */
    @RequiresPermissions("purchase:offlinepayment:view")
    @GetMapping("/nextnid")
    @ResponseBody
    public AjaxResult nextNid(@RequestParam Map<String, Object> params){
        params.put("moduleTable", moduleTable);
        AjaxResult ajaxResult = new AjaxResult();
        try {
            ajaxResult = businessService.queryNextNid(params);
        }catch (Exception e) {
            ajaxResult = AjaxResult.error(this.getExceptionMessage(e));
        }
        return ajaxResult;
    }

    /**
     * 查询页 列表数据
     * @param params
     * @return
     * @author DH-Xxj
     */
    @RequiresPermissions("purchase:offlinepayment:list")
    @GetMapping("/list")
    @ResponseBody
    public TableDataInfo list(@RequestParam Map<String, Object> params){
        params.put("moduleTable", moduleTable);
        List<OfflinePayment> list = new ArrayList<OfflinePayment>();
        try {
            list = businessService.queryList(params);
        } catch (Exception e) {
            e.printStackTrace();
            return getDataTable(this.getExceptionMessage(e).toString());
        }
        return getDataTable(list);
    }

   

    /**
     * 数据导出Excel
     * @param params
     * @return
     * @throws Exception
     * @author DH-Xxj
     */
    @RequiresPermissions("purchase:offlinepayment:export")
    @Log(title = "线下付款申请数据导出", businessType = BusinessType.EXPORT)
    @GetMapping("/export")
    @ResponseBody
    @RepeatSubmit
    public AjaxResult export(@RequestParam Map<String, Object> params) throws Exception {
        params.put("moduleTable", moduleTable);
        params.put("entity", new OfflinePayment());

        List<OfflinePayment> list = businessService.queryList(params);

        params.put("getFieldAttributesType", "export");
        List<SysDictionaryForExport> fieldList = dictionaryForFieldService.queryExportFieldList(params);
        ExportExcelUtils<OfflinePayment> util = new ExportExcelUtils<OfflinePayment>(moduleTable,new OfflinePayment());
        return util.exportExcel(list, fieldList, "线下付款", "export");
    }


    /**
     * 导出Excel导入模板
     * @param params
     * @return
     * @throws Exception
     * @author DH-Xxj
     */
    @RequiresPermissions("purchase:offlinepayment:import")
    @Log(title = "线下付款申请数据导出", businessType = BusinessType.EXPORT)
    @GetMapping("/exporttemplate")
    @ResponseBody
    @RepeatSubmit
    public AjaxResult exportTemplate(@RequestParam Map<String, Object> params) throws Exception {
        params.put("moduleTable", moduleTable);
        params.put("entity", new OfflinePayment());

        params.put("getFieldAttributesType", "template");
        List<SysDictionaryForExport> fieldList = dictionaryForFieldService.queryExportFieldList(params);
        ExportExcelUtils<OfflinePayment> util = new ExportExcelUtils<OfflinePayment>(moduleTable,new OfflinePayment());
        return util.exportExcel(null, fieldList, "线下付款申请导入模板", "template");
    }

    /**
     * 保存数据
     * @param infoMap 必要参数：非网格字段（包括头部、底部所有显示和隐藏的字段）
     * @param infoItems 必要参数：对应实体类的json格式字符串
     * @return
     * @author DH-Xxj
     */
    @RequiresPermissions(value={"purchase:offlinepayment:add","purchase:offlinepayment:edit","purchase:offlinepayment:delete"},logical=Logical.OR)
    @Log(title = "线下付款申请", businessType = BusinessType.UPDATE)
    @PostMapping("/editpost")
    @ResponseBody
    @RepeatSubmit
    public AjaxResult editSave(@RequestParam Map<String, Object> params){
        params.put("moduleTable", moduleTable);
        AjaxResult ajaxResult = new AjaxResult();
        try {
            ajaxResult= businessService.saveData(params);
        }catch (Exception e) {
            ajaxResult = AjaxResult.error(this.getExceptionMessage(e));
        }
        return ajaxResult;
    }

    /**
     * 流转
     * @param infoMap 必要参数：非网格字段（包括头部、底部所有显示和隐藏的字段）
     * @param infoItems 必要参数：对应实体类的json格式字符串（仅需 guid）
     * @return
     * @author DH-Xxj
     */
    @RequiresPermissions("purchase:offlinepayment:flow")
    @Log(title = "线下付款申请", businessType = BusinessType.FLOWGO)
    @PostMapping("/flowgopost")
    @ResponseBody
    @RepeatSubmit
    public AjaxResult flowGoSave(@RequestParam Map<String, Object> params){
        params.put("moduleTable", moduleTable);
        AjaxResult ajaxResult = new AjaxResult();
        try {
            ajaxResult= businessService.updateFlowGo(params);
        }catch (Exception e) {
            ajaxResult = AjaxResult.error(this.getExceptionMessage(e));
        }
        return ajaxResult;
    }

    /**
     * 退回
     * @param infoMap 必要参数：非网格字段（包括头部、底部所有显示和隐藏的字段）
     * @param infoItems 必要参数：对应实体类的json格式字符串（仅需 guid）
     * @return
     * @author DH-Xxj
     */
    @RequiresPermissions("purchase:offlinepayment:flow")
    @Log(title = "线下付款申请", businessType = BusinessType.FLOWBACK)
    @PostMapping("/flowbackpost")
    @ResponseBody
    @RepeatSubmit
    public AjaxResult flowBackSave(@RequestParam Map<String, Object> params){
        params.put("moduleTable", moduleTable);
        AjaxResult ajaxResult = new AjaxResult();
        try {
            ajaxResult= businessService.updateFlowBack(params);
        }catch (Exception e) {
            ajaxResult = AjaxResult.error(this.getExceptionMessage(e));
        }
        return ajaxResult;
    }

    /**
     *
     * @param params
     * @return
     */
    @PostMapping("/generatePDF")
    @ResponseBody
    public AjaxResult generatePDF(String bid){

        AjaxResult ajaxResult = new AjaxResult();
        
        if (bid == null || bid.length() == 0) {
			return AjaxResult.error("单据不能为空");
		}
        	
        try {

            String pdfFileName = "/" + bid + ".pdf";
        	
            // 生成PDF到指定目录下
            String dir = Global.getProfile();
            Map<String, Object> param = new HashMap<String, Object>();
        	param.put("moduleTable", moduleTable);
        	param.put("entity", new OfflinePayment());
        	param.put("bid", bid);
        	List<OfflinePayment> listOfflinePayment = businessService.queryList(param);
        	OfflinePayment offlinePayment = listOfflinePayment.get(0);
        	if (listOfflinePayment == null || listOfflinePayment.size() == 0) {
    			return AjaxResult.error("单据不存在");
			}
    		// 单据总额
        	BigDecimal orderAmountAll = BigDecimal.ZERO;
        	for(OfflinePayment entity : listOfflinePayment) {
        		// 单据总额累加
        		orderAmountAll = orderAmountAll.add(new BigDecimal(entity.getAmountPaid()));
        	}
        	
        	// 流程审批过程
            List<ActHistoricActivity> historicActivityList = actProcessService.queryActHistoricActivityByProcInstId(offlinePayment.getProcInstId());
        	List<PdfUtil.OfflinePaymentDto.RowDto> rows = new ArrayList<PdfUtil.OfflinePaymentDto.RowDto>();
        	for(ActHistoricActivity entity : historicActivityList) {
        		
        		String opeTime = entity.getEndTimeFormat();
        		String opeUser = entity.getAssigneeName();
        		String opeResult = entity.getResultStatusName();
        		String opeOpinion = entity.getComment();
        		String fileName = "--";
        		PdfUtil.OfflinePaymentDto.RowDto row = new PdfUtil.OfflinePaymentDto.RowDto(opeTime, opeUser, opeResult, opeOpinion, fileName);
        		rows.add(row);
        	}
        	
        	Map<String, Object> param2 = new HashMap<String, Object>();
        	param2.put("vId", offlinePayment.getCid());
        	CompanyInfo companyInfo = companyInfoService.queryCompanyInfoByVId(param2);
        	SysUserInfo sysUserInfo = sysUserInfoService.queryByUserId(offlinePayment.getaUser());
        	
        	// 明细数据
        	List<PdfUtil.OfflinePaymentDto.DetailDto> detailArr = new ArrayList<PdfUtil.OfflinePaymentDto.DetailDto>();

        	String title = "线下付款单";
        	String createCompany = companyInfo.getvName();
        	String createTime = DateUtil.getYYYY_MM_DD_HH_mm_ss(offlinePayment.getCreateTime());
        	String code = offlinePayment.getBid();
        	String applyUser = offlinePayment.getaUser() + "/" + sysUserInfo.getUserName();
        	String applyDept = sysUserInfo.getDeptName() + "/" + offlinePayment.getaPosition();
        	String payType = "采购线下付款";
        	String payAccount = offlinePayment.getPartnerName() + "/" + offlinePayment.getvKhh() + "/" + offlinePayment.getvYhZh();
        	String payAmount = orderAmountAll.setScale(2, BigDecimal.ROUND_HALF_UP).toString();
        	String remark = offlinePayment.getvZdbz();
        	String printTime = DateUtil.getYYYY_MM_DD_HH_mm_ss(new Date());
        	String printUser = ShiroUtils.getMandatorName();
        	String printDept = ShiroUtils.getMandatorDeptName();
            PdfUtil.OfflinePaymentDto dto = new PdfUtil.OfflinePaymentDto(title, createCompany, createTime, code, applyUser, applyDept, payType, payAccount, payAmount, remark, printTime, printUser, printDept, detailArr, rows);
            PdfUtil.generateOfflinePaymentPdf(dir, pdfFileName, dto);
            String data = "/profile" + pdfFileName;
            ajaxResult = AjaxResult.success("配货清单打印",data);
        }catch (Exception e) {
        	e.printStackTrace();
            ajaxResult = AjaxResult.error(this.getExceptionMessage(e));
        }
        return ajaxResult;
    }

}
